2013-05-08 - 4674.1200 - Rel Notes - BI Reports Issues - Release 007 #BIReleases2013

Release Notes:

4674.1200 - BI Reports Issues - WMS600


Admin Info

Purpose
 To fix the issues in BOBI 4.0 Production server
Release No
 007
Submitted
 05-08-2013
Submitted by
 Praveen Guntuka
Source/Destination Systems
 IT > BMS > Quality to IT > BMS > Production in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Praveen Guntuka
Object(s) Tested By
 Praveen Guntuka

Report Name

WMS600 - GSCI Exceptions

Name(s) of Tables Used

J_3ABDBS [AFS Requirement - Stock assignment]
MSKA [Sales Order Stock]
LIKP [SD Document: Delivery Header Data]
LIPS [SD document: Delivery: Item data]
VTTK [Shipment Header]
VTTP [Shipmetn item]
VBFA [Sales Document Flow]
EKBE [History per Purchasing Document]
EKES [Vendor Confirmations]
EKKO [Purchasing Document Header]
EKPO [Purchasing Document Item]
LFA1 [Vedor Master (General Section)]

NEC Crystal Reports Standards Check

1. WMS600 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. WMS600 NEC CR checklist has been sent to NEC and also attached here for reference:
WMS600 NEC CR Standard Check List.xlsx

Summary Level Check

Test Conducted

Sub-Report : PO Acknowledged not MIGOd
Vendor Account No. 0000202506 INNOVISION HEADWEAR C/O MEI FAI HAT C/O MEI FAI HATS INTERNAT
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 PO Nubmer
 4500076567
 4500076567
 Pass
2
 Item Number
 00010
 00010
 Pass
3
 Acknowledge Data
 3/13/2013
 3/13/2013
 Pass
4
 ICD Date
 6/28/2013
 6/28/2013
 Pass

Vendor Account No. 0000202659 ASIAN SOURCING HEADWEAR
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 PO Nubmer
 4500075803
 4500075803
 Pass
2
 Item Number
 00010
 00010
 Pass
3
 Acknowledge Data
 3/8/2013
 3/8/2013
 Pass
4
 ICD Date
 8/23/2013
 8/23/2013
 Pass

Sub-Report : Unallocated Stock
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Order#
 416317
 416317
 Pass
2
 Qty
 2
 2
 Pass

SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Order#
 604305
 604305
 Pass
2
 Qty
 1
 1
 Pass

Sub-Report : Allocated not on Delivery
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Order#
 Null
 Null
 Pass
2
 Qty
 Null
 Null
 Pass

Sub-Report : Delivery Created not on Shipment
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Delivery
 0081549593
 0081549593
 Pass
2
 Create Date
 04/06/2013
 04/06/2013
 Pass
3
 Sales Order Number
 398020
 398020
 Pass

SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Delivery
 081586261
 081586261
 Pass
2
 Create Date
 05/06/2013
 05/06/2013
 Pass
3
 Sales Order Number
 481650
 481650
 Pass

Sub-Report : Shipment not Started
Shipment Created by ADAKIM
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Shipment
 0000004211
 0000004211
 Pass
2
 Status
 1
 1
 Pass
3
 Shipment Create Date
 3/27/2013
 3/27/2013
 Pass

Shipment Created by BREDON
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Shipment
 0000004435
 0000004435
 Pass
2
 Status
 0
 0
 Pass
3
 Shipment Create Date
 5/6/2013
 5/6/2013
 Pass

Sub-Report : Shipment in Process
Shipment Created by CHRBID
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Shipment
 0000004233
 0000004233
 Pass
2
 Status
 6
 6
 Pass
3
 Shipment start Date
 4/12/2013
 4/12/2013
 Pass

Shipment Created by FENCHE
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Shipment
 0000004402
 0000004402
 Pass
2
 Status
 6
 6
 Pass
3
 Shipment start Date
 5/6/2013
 5/6/2013
 Pass

Sub-Report : Shipment Ended not PGId
Shipment Created by CHRBID
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Sales Order Number
 0001366204
 0001366204
 Pass
2
 Delivery
 0081511533
 0081511533
 Pass
3
 Shipment
 0000004126
 0000004126
 Pass

Shipment Created by FENCHE
SNo
 Test Case
 Value in BO 3.1
 Value in BOBI 4.0
 Pass/Fail
1
 Sales Order Number
 0001396883
 0001396883
 Pass
2
 Delivery
 0081531162
 0081531162
 Pass
3
 Shipment
 0000004191
 0000004191
 Pass

Reference Document(Specification)

2013-04-18 - 4674.1200 - Spec - BI Reports Issues